﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SKDB_Matcher.SQL.Transformations;
using System.Collections;

      //char	datetime	decimal	int	money	nchar	smallint	text	tinyint	varchar
//char	1	    0	        0	    0	0	    0,8	    0	        0,5	    0	    0,5


namespace SKDB_Matcher.SQL.DataTypeCompareResults
{
    class CDataTypeCompareResultsChar:CAbstractDataTypeCompareResult
    {
        public CDataTypeCompareResultsChar():base()
        {
            //char
            CAbstractCompareResult currentCompateResult = new CAbstractCompareResult("No Transformation needed", 100);
            this.AddCompareResult(CSQLDataType.DataType.dtChar, currentCompateResult);
            //datetime
            currentCompateResult = new CAbstractCompareResult("No Transformation possible", 0);
            this.AddCompareResult(CSQLDataType.DataType.dtDatetime, currentCompateResult);
            //decimal
            currentCompateResult = new CAbstractCompareResult("No Transformation possible", 0);
            this.AddCompareResult(CSQLDataType.DataType.dtDecimal, currentCompateResult);
            //int
            currentCompateResult = new CAbstractCompareResult("No Transformation possible", 0);
            this.AddCompareResult(CSQLDataType.DataType.dtInt, currentCompateResult);
            //money
            currentCompateResult = new CAbstractCompareResult("No Transformation possible", 0);
            this.AddCompareResult(CSQLDataType.DataType.dtMoney, currentCompateResult);
            //nchar
            currentCompateResult = new CAbstractCompareResult("TypeCast from char to nchar", 80);
            this.AddCompareResult(CSQLDataType.DataType.dtNchar, currentCompateResult);
            //smallint
            currentCompateResult = new CAbstractCompareResult("No Transformation possible", 0);
            this.AddCompareResult(CSQLDataType.DataType.dtSmallInt, currentCompateResult);
            //text
            currentCompateResult = new CAbstractCompareResult("No Transformation needed", 20);
            this.AddCompareResult(CSQLDataType.DataType.dtText, currentCompateResult);
            //tinyint
            currentCompateResult = new CAbstractCompareResult("No Transformation possible", 0);
            this.AddCompareResult(CSQLDataType.DataType.dtTinyInt, currentCompateResult);
            //varchar
            currentCompateResult = new CAbstractCompareResult("No Transformation needed", 20);
            //currentCompateResult.AddTransformation(new CTypeCast());
            this.AddCompareResult(CSQLDataType.DataType.dtvarchar, currentCompateResult);
        }
    }
}
